Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_OLAP2_AW_ATTRIBUTES

`ALL_OLAP2_AW_ATTRIBUTES` lists the attributes in standard form analytic workspaces.

The `ALL_OLAP2_AW_ATTRIBUTES` view uses the direct analytic workspace metadata access process to rapidly return information about standard form metadata. It does not use a caching mechanism and is unaffected by `CWM2_OLAP_METADATA_REFRESH`. See Chapter 19 for more information.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`AW_OWNER` | `VARCHAR2(30)` |  | Owner of the analytic workspace.
`AW_NAME` | `VARCHAR2(30)` |  | Name of the analytic workspace.
`AW_DIMENSION_NAME` | `VARCHAR2(1000)` |  | Name of the dimension in the analytic workspace.
`AW_LOGICAL_NAME` | `VARCHAR2(90)` |  | Logical name for the attribute in the analytic workspace.
`AW_PHYSICAL_OBJECT` | `VARCHAR2(1000)` |  | Standard form name for the attribute in the analytic workspace.
`DISPLAY_NAME` | `VARCHAR2(1000)` |  | Display name for the attribute.
`DESCRIPTION` | `VARCHAR2(1000)` |  | Description of the attribute.
`ATTRIBUTE_TYPE` | `VARCHAR2(1000)` |  | Type of attribute. See Table 12-1, "Reserved Dimension Attributes".
`SOURCE_OWNER` | `VARCHAR2(1000)` |  | Owner of the source attribute in the OLAP Catalog.
`SOURCE_DIMENSION_NAME` | `VARCHAR2(4000)` |  | Name of the source dimension in the OLAP Catalog.
`SOURCE_NAME` | `VARCHAR2(1000)` |  | Name of the source attribute in the OLAP Catalog.